how to incre

This sort looks more difficult than bubbling selection, inserting, and logically complicated. Intuitively, I know this is not simple, a little afraid. There is no way to give yourself a hint of psychology, be sure to read the 8 basic sorting

XtrabackupOfficial principlesin the InnoDB internally maintains a redo log file, which we can also call a transaction log file. The transaction log stores record modifications for each of the InnoDB table data. When InnoDB starts,InnoDB examines the

Remark: Install xtrabackup First: https://www.percona.com/downloads/XtraBackup/LATEST/My version here is: percona-xtrabackup-24-2.4.6-2.el7.x86_64.rpmLocal installation: Yum Localinstall percona-xtrabackup-24-2.4.6-2.el7.x86_64.rpmView 650)

Today in the use of MySQL but do not know how to deal with, insert a record do not know how to get the ID just inserted, after checking the document found select LAST_INSERT_ID (), after inserting the query to get the ID, overjoyed. You can't get

IntroductionI have been from the touch programming, has been a C + + program ape, because I like to program, the kind of grounding gas feeling, think only the use of their own management memory, psychological only practical. But with the increasing

How the database is backed up热备份：不影响业务的正常读写温备份：对表加锁，只允许对数据库进行读操作冷备份：业务暂停物理备份：备份mysql相关的数据文件逻辑备份：将数据从mysql中导出来，一般是一个sql文件（无索引数据）全备份：完全备份增量备份：针对上一次备份进行叠加差异备份：针对上一次完全备份，选择差异进行备份Using mysqldump BackupLogical backup, single process (slow), lock table

The original text turns from:http://blog.csdn.net/dbanote/article/details/13295727Application scenario: ************************************************************************************************1. Backup directory is/ The Backup/full

Xtrabackup Auto-Restore v2************************************************************************************************Application Scenarios:************************************************************************************************1. The

1.2 Hill SortHill sort belongs to the insertion sort, is the optimization of the direct insertion sort, the main idea is: because in the case of the sequence is basically orderly, the efficiency is very high, then we introduce an increment incre,

MySQL backup script, record:Fully prepared:#!/bin/sh set -x                                                               user=root password=123456time= ' date + '% Y-%m-%d-%h-%m "'   date >> /data/mysqlbackup/logs/$time ' _allbackup.log '    #1